object DM: TDM
  OldCreateOrder = False
  OnCreate = DataModuleCreate
  Height = 371
  Width = 785
  object conn: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=20150316;Persist Security Info=True' +
      ';User ID=sa;Initial Catalog=IPR_OnlineExamSys_ZZ;Data Source=172' +
      '.16.2.55;Use Procedure for Prepare=1;Auto Translate=True;Packet ' +
      'Size=4096;Workstation ID=ZHAOJG-PC;Use Encryption for Data=False' +
      ';Tag with column collation when possible=False'
    LoginPrompt = False
    Provider = 'SQLOLEDB.1'
    Left = 8
    Top = 8
  end
  object qryPub: TADOQuery
    Connection = conn
    Parameters = <>
    Left = 48
    Top = 8
  end
  object dsExam: TDataSource
    DataSet = qryExam
    Left = 376
    Top = 72
  end
  object qryTopicDis: TADOQuery
    Connection = conn
    CursorType = ctStatic
    AfterOpen = qryTopicDisAfterOpen
    Parameters = <>
    SQL.Strings = (
      'select * from tb_TiK order by bh')
    Left = 104
    Top = 8
  end
  object dsTopicDis: TDataSource
    DataSet = qryTopicDis
    Left = 104
    Top = 72
  end
  object qryStzjDis: TADOQuery
    Connection = conn
    Parameters = <>
    Left = 168
    Top = 9
  end
  object dsStzjDis: TDataSource
    DataSet = qryStzjDis
    Left = 168
    Top = 73
  end
  object qryPaperMa: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from pe_paperma order by paperbh')
    Left = 240
    Top = 9
  end
  object dsPaperMa: TDataSource
    DataSet = qryPaperMa
    Left = 240
    Top = 73
  end
  object qryPaperDe: TADOQuery
    Connection = conn
    CursorType = ctStatic
    AfterPost = qryPaperDeAfterPost
    Parameters = <>
    SQL.Strings = (
      'select * from t_paperde order by paperbh,tikbh')
    Left = 296
    Top = 8
  end
  object dsPaperDe: TDataSource
    DataSet = qryPaperDe
    Left = 304
    Top = 72
  end
  object qryExam: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from t_examinfo order by exambh')
    Left = 376
    Top = 8
  end
  object qryZsd: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from  tb_stzj')
    Left = 104
    Top = 152
  end
  object dsZsd: TDataSource
    DataSet = qryZsd
    Left = 104
    Top = 208
  end
  object qryExamTestRPMa: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select jg.ksls,gh,xm,ksmf,ksjg,kssj, CONVERT(varchar,(ksys / 60)' +
        ')+'#39#20998#38047#39'+convert(varchar,ksys%60)+'#39#31186#39' as ksys,'
      '  ex.examname as exambh,pa.papername as paperbh '
      ' from llksjg jg,t_examinfo ex,t_paperMa pa'
      ' where jg.ksls='#39'20180420132838145'#39' and jg.paperbh=pa.paperbh'
      ' and jg.exambh=Ex.examid')
    Left = 192
    Top = 161
  end
  object qryExamTestRPDe: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select id,ksls,case when tix=0 then '#39#21028#26029#39064#39' else '#39#36873#25321#39064#39' end as tix,' +
        'stbh,rightanswer,ksanswer,CONVERT(varchar,fs)+'#39#20998#39' as fs'
      '  from llksjginfo where ksls='#39'20180528155644810'#39)
    Left = 296
    Top = 168
  end
  object qryTestFind: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select jg.ksls,gh,xm,ksmf,ksjg,kssj, CONVERT(varchar,(ksys / 60)' +
        ')+'#39#20998#38047#39'+convert(varchar,ksys%60)+'#39#31186#39' as ksys,'
      '  ex.examname as exambh,pa.papername as paperbh '
      ' from llksjg jg,t_examinfo ex,t_paperMa pa'
      
        ' where  jg.paperbh=pa.paperbh and jg.exambh=Ex.examid and jg.ksl' +
        's='#39'20180420132838145'#39' ')
    Left = 416
    Top = 216
  end
  object dsTestFind: TDataSource
    DataSet = qryTestFind
    Left = 416
    Top = 280
  end
  object qryPub2: TADOQuery
    Connection = conn
    Parameters = <>
    Left = 48
    Top = 72
  end
  object qryLxFind: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from tb_TrainLog')
    Left = 488
    Top = 215
  end
  object dsLxFind: TDataSource
    DataSet = qryLxFind
    Left = 488
    Top = 279
  end
  object qryExamTj: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select exambh,count(1) as cnt,AVG(ksmf) as ksmf,avg(ksjg) as pjf' +
        ',max(ksjg) as zgf,min(ksjg) as zdf, '
      
        ' CONVERT(varchar,( AVG(ksys) / 60))+'#39#20998#38047#39'+convert(varchar, AVG(ks' +
        'ys)%60)+'#39#31186#39' as pjys from ('
      
        'select jg.ksls,gh,xm,CONVERT(int,ksmf) as ksmf,CONVERT(int,ksjg)' +
        ' as ksjg, CONVERT(int,ksys) as ksys,'
      '  ex.examname as exambh,pa.papername as paperbh '
      ' from llksjg jg,t_examinfo ex,t_paperMa pa'
      ' where  jg.paperbh=pa.paperbh and jg.exambh=Ex.examid '
      ') t1 group by exambh order by exambh')
    Left = 560
    Top = 223
  end
  object dsExamTj: TDataSource
    DataSet = qryExamTj
    Left = 560
    Top = 279
  end
  object qryLxTj: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select gh,username,count(1) as cnt,sum(case when sresult=tresult' +
        ' then 1 else 0 end) as zqs,'
      
        '  sum(case when sresult<>tresult then 1 else 0 end) as cws from ' +
        'tb_TrainLog'
      'group by gh,username')
    Left = 624
    Top = 222
  end
  object dsLxTj: TDataSource
    DataSet = qryLxTj
    Left = 624
    Top = 278
  end
  object qryClientSn: TADOQuery
    Connection = conn
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from pe_clientsn')
    Left = 440
    Top = 11
  end
  object dsClientSn: TDataSource
    DataSet = qryClientSn
    Left = 440
    Top = 75
  end
end
